Spi Interview Questions:

1.About Yourself
2)what is DML
3.Diff B/W Delete and Truncate
4.Views
5.M Views
6.do u know Bulk collect?
7.Write a query to display employee’s name whose ID’s are not mapped with any department.
8.Write a Procedure with two inputs 1----> Input string(‘Dhoni’)   2--- Searching letter (‘h’)and the procedure should display the position of the letter ‘h’
9.Write a query to display sequence numbers from 1 to 30
10.Write a function, where it should accept one input (i.e. emp_id) if the Emp_id exists in DB then we should update the salary as 10000 for that particular Emp_id or it should display an error message saying “The EMP_ID does not exist”
11.Triggers